PAYTYPE

The PAYTYPE dimension table includes records for all possible categories of compensation that an employee might receive (for example, regular pay, paid time off, sick pay, incentive pay, and so on).

For more information about how to set up the PAYTYPE dimension for reporting, budgeting, and GL mapping, see Map the PAYTYPE dimension.

NOTE: Some dimension tables are shared across multiple Axiom products. As a result, some of the columns listed in the following table might not be displayed in the dimension, depending on the Axiom products for which your organization is licensed.

The following table lists all of the options available in this dimension table:

Column	Description
PAYTYPE	The Axiom pay type. The PAYTYPE must be an alpha-numeric field so that during the import process, a P is prepended to all pay types to ensure they are alpha-numeric.
Description	Identifies the pay type description from the payroll system. Be as explicit as possible, avoid abbreviations, and use layman’s terms. Do not enter a description using all capital letters. To remove the all-caps format in the spreadsheet, use the Proper formula =Proper().
PaySummary	Used in reporting to identify major pay categories. Select one of the valid entries: Prod NonProd Other Stat NA
PayDetail	Used in reporting to identify detail pay categories. Select one of the valid entries: Contract NA NonProd Other Overtime Regular Stat
LaborDist	The variation of PayDetail used in Labor Distribution reporting. Valid entries include the following: Regular Education Orientation PTO Overtime OnCall Other Contract Stat NA
FTE	Indicates whether to include hours in FTE calculations. Select one of the valid entries: To assign to pay types to count for FTE calculations such as Regular, Overtime, Education, PTO, Jury Duty, Bereavement, Sick, and so on, select Yes. To assign to pay types to not count for FTE calculations such as Differentials, Call Pay (not callback), Bonus, Benefits, and so on, select No. To assign to your productivity stat pay types, select Stat. If none of the above scenarios apply, select NA.
Empl_Detail	Identifies pay types that are FTE-related for employee-level budgeting. Select one of the valid entries: If FTE-related, select Z_Employee. If not FTE-related, select NA.
KHAInt	Identifies pay types to include in plan file processing. Select one of the following entries: To assign pay types to include in the JobCode block (generally FTE=Yes), select JobCode. To assign pay types to include in the JobCode block as additional dollars (generally, FTE=No), select Dollars. Examples include call pay, differentials, bonus, and so on. To assign pay types to budget at the department (not job code) level, select Dept. To assign pay types to exclude from the budget workbooks such as PTO sellback, reimbursement\adoption reimbursement, car allowance, benefit expenses, and so on, select NA.
PHYInt	Differentiates the hours and dollars that are processed by the hospital versus those processed by provider plan files. Different classifications are assigned to pay types to identify which pay types interface data to the provider plan files during processing. Select one of the following entries: To assign pay types to include in the JobCode block (generally FTE=Yes), select JobCode. To assign pay types to include in the JobCode block as additional dollars (generally FTE=No), select Dollars Examples include call pay, differentials, bonus, and so on). To assign pay types to budget at the department (not job code) level, select Dept. To assign pay types to exclude from the budget workbooks such as PTO sellback, reimbursement\adoption reimbursement, car allowance, benefit expenses, and so on, select NA.
GLAcct	Identifies the account number for dollars on the GL. Do one of the following: If your payroll data maps to the GL-based upon job code, type 0 (zero). If your payroll data does not map to the GL-based on job code, type the GL salary account from the ACCT dimension table.
HrAcct	Identifies the account number for hours on the GL. Do one of the following: If your payroll hours map to the GL-based upon job code, type 0 (zero). If your payroll hours do not map to the GL-based on job code, type the GL hours account from the ACCT dimension table.
FTEAcct	Identifies the account number for FTEs on the GL. Do one of the following: If you payroll FTEs map to the GL based on job code, type 0 (zero). If your payroll FTEs do not map to the GL based on job code, type the GL FTEs account from the ACCT dimension table. To calculate FTEs based on GL Hours and not map FTE values to the GL, type 0 (zero).
JobCode	The pay type summary groupings used for plan-file processing when using the Jobcode labor method. The code used must be a valid pay type.
Staffing	The pay type summary groupings used for plan-file processing when using the Staffing labor method. The code used must be a valid pay type.
Employee	The pay type summary groupings used for plan-file processing when using the Employee labor method. The code used must be a valid pay type. NOTE: The standard delivered pay type code of Z_Employee must maintain the classification of "Z_Employee" under the Employee column to provide the correct classification needed by the Employee calculation method.
Provider	The pay type summary groupings used for plan-file processing when using the ProviderComp labor method. The code used must be a valid pay type.
KHAStdLine	Identifies default budget methodology used in budget plan files during budget plan file creation. Refer to Calculation methods for valid entries and definitions. The default value is NA. Jobcode (used to build the standard pay type block in plan files) AvgPerProdHr (Dollars) AvgPerPaidHr (Dollars) Dollars_History (Dollars) GlobalPremium (Dollars) Holiday (Dollars) Input_Monthly (Dollars) DeptAvgPerProdHr (Dept) Dept_InputMonthly (Dept) Dept_InputTotal (Dept) NA
PHYStdLine	Identifies the default budget methodology used in Provider Support Staff budget plan files during budget plan file creation. Options include: Jobcode (used to build the standard pay type block in the plan file) AvgPerProdHr (Dollars) AvgPerPaidHr (Dollars) GlobalPremium (Dollars) Input_Monthly (Dollars) Dept_AvgPerProdHr (Dept) Dept_InputMonthly (Dept)
RF_Pay26_Include_Exclude	Select whether to include or exclude this option from monthly payroll to GL.
CDMStdLine	Identifies default budget methodology for CDM budget plan files (departments which have CDMStdLine in KHACMDimGrp column of DEPT Dimension) during budget plan file creation. It is used similarly to KHAStdLine in Budget Planning workbooks. Valid entries include the following: Statistical accounts = CDMStatistic IP Revenue accounts = CDMIPRevenue OP Revenue accounts = CDMOPRevenue Copy the remaining account assignments from KHAStdLine column.
CM_PlanCode	Combines pay types during Axiom Cost Management reporting and plan-file creation. If historical values exist for two pay types that you want to report as one combined pay type, list the surviving pay type on both lines.
NewDeptStdLine	Set up or update the calc method for each department and use it in conjunction with the New Department Utility, which resides at \Axiom\File Groups\Budget-2022\Utilities (from Budget-2022 File Group). In that utility, you can populate the NYBKHA field of the various actual tables for accounts/paytypes/jobcodes for a new department. After those tables are set up, use the NewDeptStdLine column in the PAYTYPE dimension to define which calculation methods to use (because there is no historical data from which to build). You can assign NewDeptStdLine to the department in the Dept dimension using the KHACMDimGroup grouping column.
Accrue	Identifies paytypes to be included when using the payroll accrual utility. Valid entries include the following: • To accrue during monthly payroll accrual process, type Yes. • To not accrue during monthly payroll accrual process, type No or NA.
CM_PayCategory	Used in Axiom Cost Management to group individual pay types into summary categories for planning purposes. Examples include: Regular Overtime Education PTO Contract Other Stat.
Cost Variable	Not used at this time.
KHAStandardClass	Grouping column to report on paytype usage across your organization.
CM_Paid	Identifies the pay type to include in the Paid Hours calculations in Axiom Cost Management. Valid entries include the following: For paytypes that are included in paid hours, select Yes. For paytypes that are not included in paid hours, select No.
CM_Worked	Identifies the pay type to include in the Worked Hours calculations in Axiom Cost Management. For Pay Types that are included in worked hours, select Yes. For Pay Types that are not included in worked hours, select No.
CM_PaidDLLRS	Identifies the pay type to include in the Paid Dollars calculations in Axiom Cost Management. For Pay Types that are included in paid dollars, select Yes. For Pay Types that are not included in paid dollars, select No.
CM_WorkedDLLRS	Identifies the pay type to include in the Worked Dollars calculations in Axiom Cost Management. For Pay Types that are included in worked dollars, select Yes. For Pay Types that are not included in worked dollars, select No.
CMStdLine	Used during the interface process to assign the standard planning method for each pay type. Identifies the required formula to calculate Axiom Cost Management initiatives. It is used similarly to KHAStdLine in Budget Planning workbooks.
RFPAYCLASS	The Rolling Forecasting pay type class.
cv2_ResourceCalculation	Determines the calculation behavior for the hours or dollars within the PAYTYPE when using the payroll information within the RVU development process. When labor rates are calculated for the Resource table, this designation determines if the Hours, Dollars, or Both are used in the numerator and denominator in the average.